Installing Mysql

Ok so the video I’ve been following is starting with MySQL, and Popsql as a text editor.

The video directed us to This is the mysql websiite Then made my way to the community server as instructed ( points for being a good student? )

1. Download : Download MySQL Community Server
2. I’m going to follow the steps laid out on this video as I think he does a great job at this process.
3. Ok so my installation process varied slightly so far. I needed to choose the right version (NOT THE ARM VERSION) then when it came to completing the process, it asked me to create a password for root instead of giving me one to change later in the process. It also configued itself to auto run on start ( which i hope that doesnt come to bite me in the butt later on)
4. This guy is typing a funky looking “command” in terminal which his reasoning is, “basically mac doesnt know about mysql commands…We have to tell our computer where we installed mysql” . (It seems like even though we downloaded mysql , the computer has no idea what that is nor what to do with it )
   1. Command in question : echo ‘export PATH=/usr/local/mysql/bin:$PATH’ >> ~/.bash_profile
   2. Something I sourced from stackoverflow ¹
   3. So to my understanding : PATH=/USR/LOCAL/MYSQL is where we are keeping mySQL
   4. We are associating it to ~/.bash_profile which would be the profile that is being used in terminal . In my case its “firstname@macbookpro ~ %
   5. The same thread answer as the picuture above states, “ ”export” makes the change visible to new programs launched by bash” ²
5. The guy in the video says that the funky looking command is adding the first half ( before the >>) into the bash _profile. While I believe the guy does a great job of explaining the process I wanted to digest it my own way for further clarification. Hope that explains it .

Also why arent installers already doing this by automatically??!!

And we’re back to the video..

Azure Data Studio

The rest of the installation part of the video revolved around installing PopSql to visualize MySQL better. I decided to use Azure Data Studio instead as I read that even though SSMS aka SQL SERVER MANAGEMENT STUDIO ( a Microsoft product) is the “industry standard” Azure Data Studio was up there as a good alternative ( especially if you are a MAC user) . Again, hope that doesnt come back to bite my in the butt. Installation process: I downloaded ADS from this site Once you open it youll realize that it fucking looks like VScode!

First you have to download the mysql extension to use MySql’s version of SQL.

Click “New Conncetion” > Connection type : Mysql Server name : Localhost > Authentication type: “password”

Username : “root” . Then you use the password that you created when you first downloaded mysql

Image for reference.